Plot routes on SHN¶

See what highway corridors show up.

Can span multiple operators. These corridors, if improved, would benefit all operators.

Brainstorm¶

Filter to just routes that are on SHN.

In top 75% of trips_all_day_per_mi...mostly to select out where trips occur on highways OR
<= 25 mph average for RT speeds, relatively slow speeds for routes that are running on SHN! Only if RT info is present (not always available for express buses)

/opt/conda/lib/python3.10/site-packages/geopandas/_compat.py:112: UserWarning: The Shapely GEOS version (3.10.3-CAPI-1.16.1) is incompatible with the GEOS version PyGEOS was compiled with (3.10.1-CAPI-1.16.0). Conversions between both will be slow.
  warnings.warn(

	Route	District	hwy_segment_id	trips_peak	trips_all_day	stop_arrivals_peak	stop_arrivals_all_day	stops_peak	stops_all_day	route_length	trips_peak_per_mi	stop_arrivals_peak_per_mi	stop_arrivals_all_day_per_mi	stops_peak_per_mi	stops_all_day_per_mi	trips_all_day_per_mi	trips_all_day_per_mi_group	mean_speed_mph_trip_weighted	mean_speed_mph_trip_weighted_group
count	45.000000	45.000000	4.500000e+01	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000	45.000000
mean	88.911111	7.311111	2.288938e+09	66.955556	114.444444	83.422222	171.222222	5.311111	5.377778	14683.680165	65.723556	62.440667	126.990222	3.775556	3.788889	113.374222	2.911111	23.328667	2.177778
std	82.761932	2.447840	1.224283e+09	69.625281	116.766581	93.500970	192.884550	5.857482	5.874788	10554.022068	106.654729	83.957042	170.710654	3.872039	3.863522	185.802707	0.949216	7.460918	1.072145
min	1.000000	3.000000	1.285190e+08	6.000000	10.000000	3.000000	5.000000	1.000000	1.000000	597.262930	1.200000	0.600000	1.000000	0.200000	0.200000	2.000000	2.000000	6.980000	1.000000
25%	27.000000	6.000000	1.515119e+09	17.000000	34.000000	13.000000	28.000000	2.000000	2.000000	3066.942722	10.740000	16.110000	28.190000	1.000000	1.400000	18.790000	2.000000	17.000000	1.000000
50%	74.000000	7.000000	2.302459e+09	48.000000	80.000000	55.000000	114.000000	3.000000	3.000000	15735.575795	26.050000	35.360000	79.560000	2.010000	2.010000	49.280000	3.000000	22.640000	2.000000
75%	110.000000	8.000000	3.130616e+09	59.000000	100.000000	95.000000	188.000000	6.000000	6.000000	26400.000000	84.820000	62.590000	127.600000	5.200000	5.200000	159.130000	4.000000	29.730000	3.000000
max	282.000000	12.000000	4.265316e+09	238.000000	397.000000	354.000000	716.000000	26.000000	26.000000	26400.000000	635.970000	435.140000	903.750000	16.030000	16.030000	1121.320000	4.000000	38.020000	4.000000

speed cutoff: 20, trip quartile cutoff: 2
# obs statewide: 114

4     49
7     32
11    14
8     10
10     7
12     2
Name: District, dtype: int64

District 1¶

No highway corridors meet this criteria.